﻿<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html>
  <head>
    <META http-equiv="Content-Type" content="text/html; charset=utf-8">
    <title>
                    xUnit.net Test Results - </title>
    <style type="text/css">
                    body { font-family: Calibri, Verdana, Arial, sans-serif; background-color: White; color: Black; }
                    h2,h3,h4,h5 { margin: 0; padding: 0; }
                    h3 { font-weight: normal; }
                    h5 { font-weight: normal; font-style: italic; margin-bottom: 0.75em; }
                    pre { font-family: Consolas; font-size: 85%; margin: 0 0 0 1em; padding: 0; }
                    .divided { border-top: solid 1px #f0f5fa; padding-top: 0.5em; }
                    .row, .altrow { padding: 0.1em 0.3em; }
                    .row { background-color: #f0f5fa; }
                    .altrow { background-color: #e1ebf4; }
                    .success, .failure, .skipped { font-family: Arial Unicode MS; font-weight: normal; float: left; width: 1em; display: block; }
                    .success { color: #0c0; }
                    .failure { color: #c00; }
                    .skipped { color: #cc0; }
                    .timing { float: right; }
                    .indent { margin: 0.25em 0 0.5em 2em; }
                    .clickable { cursor: pointer; }
                    .testcount { font-size: 85%; }
                </style><script language="javascript">
                    function ToggleClass(id) {
                        var elem = document.getElementById(id);
                        if (elem.style.display == "none") {
                            elem.style.display = "block";
                        }
                        else {
                            elem.style.display = "none";
                        }
                    }
                </script></head>
  <body>
    <h3 class="divided"><b>Assemblies Run</b></h3>
    <div>E:\andrei\PMKB\PMKB_Testing\bin\Debug\PMKB_Testing.dll</div>
    <h3 class="divided"><b>Summary</b></h3>
    <div>
                    Tests run: <a href="#all"><b>5</b></a>  
                    Failures: <a href="#failures"><b>0</b></a>,
                    Skipped: <a href="#skipped"><b>0</b></a>,
                    Run time: <b>13.45s</b></div><br><h2><a name="all"></a>All tests</h2>
    <h5>Click test class name to expand/collapse test details</h5>
    <h3><span class="timing">13.450s</span><span class="clickable" onclick="ToggleClass('classID0EO')" ondblclick="ToggleClass('classID0EO')"><span class="success">✔</span>
                 PMKB_Testing.clsAddTagsAndLinks
                 <span class="testcount">(5 tests)</span></span><br clear="all"></h3>
    <div class="indent" style="display: none;" id="classID0EO">
      <div class="row"><span class="timing">10.093s</span><span class="success">✔</span>
             Given a new database and inserting tags and a link change the tag name, remains same name as tag<br clear="all"><h4>Output</h4>
        <pre>Before : PMKB_Testing.clsAddTagsAndLinks.RenameTag
TagID=0;TagName=codeplex;
TagID=0;TagName=links;
TagID=0;TagName=documents;
TagID=0;TagName=FAQ;
TagID=0;TagName=HELP;
UserID=0;UserName=andrei;
LinkID=0;LinkName=aa;LinkDescription=b;LinkUrl=a;CreationUserID=1;LinkCreationDate=1/8/2012 11:07:15 PM;LinkShortURL=;
INSERT INTO [Link_OLAP]
           ([LinkID]
           ,[LinkName]
           ,[LinkDescription]
           ,[LinkUrl]
           ,[CreationUserID]
           ,[LinkCreationDate]
           ,[LinkShortURL]
           ,[UserName]
           )
   select l.[LinkID]
           ,l.[LinkName]
           ,l.[LinkDescription]
           ,l.[LinkUrl]
           ,l.[CreationUserID]
           ,l.[LinkCreationDate]
           ,l.[LinkShortURL]
           ,u.[UserName]
from [Link] l inner join [User] u
on l.[CreationUserID] = u.UserID
left outer join [Link_OLAP] o on l.LinkID = o.LinkID
where o.LinkID is null
